postgres=# \x
postgres=# select * from pg_stat_all_tables where relname in ('accp','pg_shdepend')
postgres-# or relname like 'cr_pt_e_202405%' order by relname;
-[ RECORD 1 ]-------+--------------------------------------------------
relid               | 811486381
schemaname          | a
relname             | accp
seq_scan            | 1661787
seq_tup_read        | 905357338
idx_scan            | 248533779
idx_tup_fetch       | 655158328
n_tup_ins           | 3655469
n_tup_upd           | 0
n_tup_del           | 3220871
n_tup_hot_upd       | 0
n_live_tup          | 490
n_dead_tup          | 1673487
n_mod_since_analyze | 392
n_ins_since_vacuum  | 1673683
last_vacuum         |
last_autovacuum     | 2024-05-15 03:25:16.007386+00
last_analyze        | 2024-05-21 12:51:09.114787+00
last_autoanalyze    | 2024-05-15 03:25:16.008873+00
vacuum_count        | 0
autovacuum_count    | 1888
analyze_count       | 26856
autoanalyze_count   | 1715
-[ RECORD 2 ]-------+--------------------------------------------------
relid               | 922801367
schemaname          | a
relname             | cr_pt_e_202405010000_202405020000
seq_scan            | 47
seq_tup_read        | 20302955
idx_scan            | 241500
idx_tup_fetch       | 64456
n_tup_ins           | 0
n_tup_upd           | 0
n_tup_del           | 0
n_tup_hot_upd       | 0
n_live_tup          | 1450324
n_dead_tup          | 0
n_mod_since_analyze | 0
n_ins_since_vacuum  | 0
last_vacuum         |
last_autovacuum     |
last_analyze        | 2024-05-09 08:59:41.62695+00
last_autoanalyze    |
vacuum_count        | 0
autovacuum_count    | 0
analyze_count       | 1
autoanalyze_count   | 0
-[ RECORD 3 ]-------+--------------------------------------------------
relid               | 923130055
schemaname          | a
relname             | cr_pt_e_202405020000_202405030000
seq_scan            | 1264
seq_tup_read        | 8800722491
idx_scan            | 4601405
idx_tup_fetch       | 4415621
n_tup_ins           | 3851400
n_tup_upd           | 15790
n_tup_del           | 0
n_tup_hot_upd       | 0
n_live_tup          | 7166325
n_dead_tup          | 0
n_mod_since_analyze | 0
n_ins_since_vacuum  | 0
last_vacuum         |
last_autovacuum     | 2024-05-03 09:03:44.810654+00
last_analyze        | 2024-05-09 08:44:37.725674+00
last_autoanalyze    | 2024-05-03 09:03:58.838664+00
vacuum_count        | 0
autovacuum_count    | 1
analyze_count       | 1
autoanalyze_count   | 1
-[ RECORD 4 ]-------+--------------------------------------------------
relid               | 923492271
schemaname          | a
relname             | cr_pt_e_202405030000_202405040000
seq_scan            | 49
seq_tup_read        | 17146395
idx_scan            | 2516428
idx_tup_fetch       | 263394464
n_tup_ins           | 1221170
n_tup_upd           | 28186
n_tup_del           | 0
n_tup_hot_upd       | 0
n_live_tup          | 1221081
n_dead_tup          | 0
n_mod_since_analyze | 0
n_ins_since_vacuum  | 97850
last_vacuum         |
last_autovacuum     | 2024-05-03 22:23:52.923897+00
last_analyze        | 2024-05-09 08:34:56.67582+00
last_autoanalyze    | 2024-05-03 23:40:05.055661+00
vacuum_count        | 0
autovacuum_count    | 7
analyze_count       | 1
autoanalyze_count   | 19
-[ RECORD 5 ]-------+--------------------------------------------------
relid               | 923703041
schemaname          | a
relname             | cr_pt_e_202405040000_202405050000
seq_scan            | 49
seq_tup_read        | 20317780
idx_scan            | 2404969
idx_tup_fetch       | 23974762973
n_tup_ins           | 1451270
n_tup_upd           | 42958
n_tup_del           | 0
n_tup_hot_upd       | 0
n_live_tup          | 1451368
n_dead_tup          | 0
n_mod_since_analyze | 0
n_ins_since_vacuum  | 0
last_vacuum         |
last_autovacuum     | 2024-05-09 07:37:07.984628+00
last_analyze        | 2024-05-09 08:45:49.581849+00
last_autoanalyze    | 2024-05-09 07:37:15.986243+00
vacuum_count        | 0
autovacuum_count    | 19
analyze_count       | 1
autoanalyze_count   | 5
-[ RECORD 6 ]-------+--------------------------------------------------
relid               | 924013058
schemaname          | a
relname             | cr_pt_e_202405050000_202405060000
seq_scan            | 46
seq_tup_read        | 20346620
idx_scan            | 1677570
idx_tup_fetch       | 62821556003
n_tup_ins           | 1453330
n_tup_upd           | 43044
n_tup_del           | 0
n_tup_hot_upd       | 0
n_live_tup          | 1453377
n_dead_tup          | 0
n_mod_since_analyze | 0
n_ins_since_vacuum  | 0
last_vacuum         |
last_autovacuum     | 2024-05-09 07:38:29.862644+00
last_analyze        | 2024-05-09 09:06:45.596016+00
last_autoanalyze    | 2024-05-09 07:38:46.638095+00
vacuum_count        | 0
autovacuum_count    | 1
analyze_count       | 1
autoanalyze_count   | 1
-[ RECORD 7 ]-------+--------------------------------------------------
relid               | 924322992
schemaname          | a
relname             | cr_pt_e_202405060000_202405070000
seq_scan            | 46
seq_tup_read        | 20317780
idx_scan            | 1547942
idx_tup_fetch       | 42808203048
n_tup_ins           | 1451270
n_tup_upd           | 43099
n_tup_del           | 0
n_tup_hot_upd       | 0
n_live_tup          | 1451352
n_dead_tup          | 0
n_mod_since_analyze | 0
n_ins_since_vacuum  | 0
last_vacuum         |
last_autovacuum     | 2024-05-09 07:38:38.204882+00
last_analyze        | 2024-05-09 09:17:08.164641+00
last_autoanalyze    | 2024-05-09 07:38:54.664434+00
vacuum_count        | 0
autovacuum_count    | 1
analyze_count       | 1
autoanalyze_count   | 1
-[ RECORD 8 ]-------+--------------------------------------------------
relid               | 924633049
schemaname          | a
relname             | cr_pt_e_202405070000_202405080000
seq_scan            | 46
seq_tup_read        | 3972817
idx_scan            | 302373
idx_tup_fetch       | 1196443546
n_tup_ins           | 281190
n_tup_upd           | 8790
n_tup_del           | 0
n_tup_hot_upd       | 0
n_live_tup          | 281190
n_dead_tup          | 0
n_mod_since_analyze | 0
n_ins_since_vacuum  | 0
last_vacuum         |
last_autovacuum     | 2024-05-09 07:37:40.345145+00
last_analyze        | 2024-05-09 09:21:34.794247+00
last_autoanalyze    | 2024-05-09 07:37:43.220323+00
vacuum_count        | 0
autovacuum_count    | 1
analyze_count       | 1
autoanalyze_count   | 1
-[ RECORD 9 ]-------+--------------------------------------------------
relid               | 924849317
schemaname          | a
relname             | cr_pt_e_202405160000_202405170000
seq_scan            | 11
seq_tup_read        | 551050
idx_scan            | 625876
idx_tup_fetch       | 23425556147
n_tup_ins           | 551050
n_tup_upd           | 16050
n_tup_del           | 0
n_tup_hot_upd       | 0
n_live_tup          | 551050
n_dead_tup          | 16050
n_mod_since_analyze | 567100
n_ins_since_vacuum  | 551050
last_vacuum         |
last_autovacuum     |
last_analyze        |
last_autoanalyze    |
vacuum_count        | 0
autovacuum_count    | 0
analyze_count       | 0
autoanalyze_count   | 0
-[ RECORD 10 ]------+--------------------------------------------------
relid               | 924961379
schemaname          | a
relname             | cr_pt_e_202405170000_202405180000
seq_scan            | 8
seq_tup_read        | 0
idx_scan            | 1576550
idx_tup_fetch       | 62495118422
n_tup_ins           | 1445090
n_tup_upd           | 42104
n_tup_del           | 0
n_tup_hot_upd       | 0
n_live_tup          | 1445090
n_dead_tup          | 42104
n_mod_since_analyze | 1487194
n_ins_since_vacuum  | 1445090
last_vacuum         |
last_autovacuum     |
last_analyze        |
last_autoanalyze    |
vacuum_count        | 0
autovacuum_count    | 0
analyze_count       | 0
autoanalyze_count   | 0
-[ RECORD 11 ]------+--------------------------------------------------
relid               | 925266104
schemaname          | a
relname             | cr_pt_e_202405180000_202405190000
seq_scan            | 8
seq_tup_read        | 0
idx_scan            | 1575404
idx_tup_fetch       | 62723304826
n_tup_ins           | 1445090
n_tup_upd           | 42107
n_tup_del           | 0
n_tup_hot_upd       | 0
n_live_tup          | 1445090
n_dead_tup          | 42107
n_mod_since_analyze | 1487197
n_ins_since_vacuum  | 1445090
last_vacuum         |
last_autovacuum     |
last_analyze        |
last_autoanalyze    |
vacuum_count        | 0
autovacuum_count    | 0
analyze_count       | 0
autoanalyze_count   | 0
-[ RECORD 12 ]------+--------------------------------------------------
relid               | 925574480
schemaname          | a
relname             | cr_pt_e_202405190000_202405200000
seq_scan            | 8
seq_tup_read        | 0
idx_scan            | 1576466
idx_tup_fetch       | 62756475943
n_tup_ins           | 1446120
n_tup_upd           | 42140
n_tup_del           | 0
n_tup_hot_upd       | 0
n_live_tup          | 1446120
n_dead_tup          | 42140
n_mod_since_analyze | 1488260
n_ins_since_vacuum  | 1446120
last_vacuum         |
last_autovacuum     |
last_analyze        |
last_autoanalyze    |
vacuum_count        | 0
autovacuum_count    | 0
analyze_count       | 0
autoanalyze_count   | 0
-[ RECORD 13 ]------+--------------------------------------------------
relid               | 925883070
schemaname          | a
relname             | cr_pt_e_202405200000_202405210000
seq_scan            | 8
seq_tup_read        | 0
idx_scan            | 1554745
idx_tup_fetch       | 55383014348
n_tup_ins           | 1445090
n_tup_upd           | 42103
n_tup_del           | 0
n_tup_hot_upd       | 0
n_live_tup          | 1445090
n_dead_tup          | 42103
n_mod_since_analyze | 1487193
n_ins_since_vacuum  | 1445090
last_vacuum         |
last_autovacuum     |
last_analyze        |
last_autoanalyze    |
vacuum_count        | 0
autovacuum_count    | 0
analyze_count       | 0
autoanalyze_count   | 0
-[ RECORD 14 ]------+--------------------------------------------------
relid               | 926191516
schemaname          | a
relname             | cr_pt_e_202405210000_202405220000
seq_scan            | 8
seq_tup_read        | 0
idx_scan            | 792634
idx_tup_fetch       | 8375236568
n_tup_ins           | 747780
n_tup_upd           | 21758
n_tup_del           | 0
n_tup_hot_upd       | 0
n_live_tup          | 747780
n_dead_tup          | 21758
n_mod_since_analyze | 769538
n_ins_since_vacuum  | 747780
last_vacuum         |
last_autovacuum     |
last_analyze        |
last_autoanalyze    |
vacuum_count        | 0
autovacuum_count    | 0
analyze_count       | 0
autoanalyze_count   | 0
-[ RECORD 15 ]------+--------------------------------------------------
relid               | 1214
schemaname          | pg_catalog
relname             | pg_shdepend
seq_scan            | 17
seq_tup_read        | 95718
idx_scan            | 15059199
idx_tup_fetch       | 2170231
n_tup_ins           | 2148565
n_tup_upd           | 0
n_tup_del           | 2148602
n_tup_hot_upd       | 0
n_live_tup          | 6991
n_dead_tup          | 16171
n_mod_since_analyze | 32342
n_ins_since_vacuum  | 16171
last_vacuum         |
last_autovacuum     | 2024-05-21 03:28:39.846993+00
last_analyze        | 2024-05-09 08:27:39.663855+00
last_autoanalyze    | 2024-05-21 03:28:39.856801+00
vacuum_count        | 0
autovacuum_count    | 584
analyze_count       | 1
autoanalyze_count   | 749